# -*- coding: utf-8 -*-

# Define your item pipelines here
#
# Don't forget to add your pipeline to the ITEM_PIPELINES setting
# See: https://doc.scrapy.org/en/latest/topics/item-pipeline.html

# zhiwei = scrapy.Field()
# gongsi = scrapy.Field()
# qian = scrapy.Field()
# miaoshu = scrapy.Field()
# dizhi = scrapy.Field()
# id = scrapy.Field()
from Find_job.insert_sql import Sql
class FindJobPipeline(object):
    def process_item(self, item, spider):

        id = item['id']
        zhiwei= item['zhiwei']
        gongsi = item['gongsi']
        qian = item['qian']
        miaoshu = item['miaoshu']
        dizhi = item['dizhi']
        xingzhi = item['xingzhi']
        hangye = item['hangye']
        guimo = item['guimo']

        Sql.Insert_data(zhiwei,gongsi,qian,miaoshu,dizhi,id,xingzhi,hangye,guimo)



        # return item
